Report Modification Example

The following example walks you through all of the steps necessary to modify a report.

Watch the video: Customizing an Existing Report

Example: You want to modify the SQL Database report to only display databases from SQL servers running Microsoft SQL Server 2008. The report in the library does not include the version in it, so you will need to add that field to the report. You are going to change the title to reflect this, so you do not need to include the version for each database. This means you will use a hidden parameter for the version, and filter the data to show only the version you choose.

To modify your SQL Database report

1.	Copy the SQL Databases report from the Report Library to My Reports.

2.	In the My Reports treeview, select the report.

3.	Click Edit Report.

4.	Change the title of the report to SQL Server 2008 Databases.

5.	Click the Fields tab, and add the Version field to the report.

Click OK in the warning dialog box. Because we do not want this field to show on the report, no layout modification is necessary. If you want to display the new field, you must add the field to the layout. For more information, see the Report Designer User Guide (Developer Express), located in the folder where you installed the Report Manager.

6.	Click the Parameters tab and click Create.

7.	Set the Usage to Hidden.

8.	In the Select the field to associated with this parameter list, click Version.

9.	In the Parameter Properties area, set the condition operator to Equals.

10.	Select the SQL version you want (for example, SQL Server 2008 is version 10.0).

11.

Click OK.

12.	Click OK in the Edit Report Definition dialog box.